package com.yd.app.mapper.provider;

import java.util.Map;

/**
 * 评价
 * Created by sunxianhui on 2018/3/7.
 */
public class GStyleProvider extends BaseProvider {
    /**
     * 获取每一页列表
     * @param map
     * @return
     */
    public String searchGStyleList(Map map) {
        StringBuilder sb = new StringBuilder("SELECT * FROM business_gStyle where 1=1 ");
        sb.append(" and goodsId=#{goodsId} ");
        sb.append(" limit #{startRow},#{pageSize} ");
        return sb.toString();
    }

    /**
     * 获取查询总数量
     * @param map
     * @return
     */
    public String searchGStyleCount(Map map) {
        StringBuilder sb = new StringBuilder(" select count(1) from business_gStyle where 1=1");
        sb.append(" and goodsId=#{goodsId} ");
        return sb.toString();
    }

}
